Create Conditional Column 9

Step 1: Right click on table name, select rename and rename table with “US School Shooting”

Step 2: Right click on US school shooting table. Select Copy and paste US school shooting table. Go to the new table, select School type column. Right click and select remove other columns, use the same process and select remove duplicate.

Step 3: Go to add column and select add conditional column. Give a name to the column (School Type Group) and then follow the GIF and the screenshot to create the column. Click OK

Step 4: Go to add column, select conditional column. Provide name to the column (School type Order) and Follow the GIF and Screenshot to create the column. Click OK

Step 5: Rename the table with School type then select close and apply


Step 1: Right click on table name, select rename and rename table with “US School Shooting


Step 2: Right click on US school shooting table. Select Copy and paste US school shooting table. Go to the new table, select School type column. Right click and select remove other columns, use the same process and select remove duplicate.



Step 3: Go to add column and select add conditional column. Give a name to the column (School Type Group) and then follow the GIF and the screenshot to create the column. Click OK




Step 4: Go to add column, select conditional column. Provide name to the column (School type Order) and Follow the GIF and Screenshot to create the column. Click OK




Step 5: Rename the table with School type then select close and apply








https://radacad.com/conditional-column-in-power-bi-using-power-query-you-can-do-anything

Conditional column in power bi  using power query

Create Conditional Column 9

Step 1: Right click on table name, select rename and rename table with “US School Shooting”

Step 2: Right click on US school shooting table. Select Copy and paste US school shooting table. Go to the new table, select School type column. Right click and select remove other columns, use the same process and select remove duplicate.

Step 3: Go to add column and select add conditional column. Give a name to the column (School Type Group) and then follow the GIF and the screenshot to create the column. Click OK

Step 4: Go to add column, select conditional column. Provide name to the column (School type Order) and Follow the GIF and Screenshot to create the column. Click OK

Step 5: Rename the table with School type then select close and apply


Step 1: Right click on table name, select rename and rename table with “US School Shooting


Step 2: Right click on US school shooting table. Select Copy and paste US school shooting table. Go to the new table, select School type column. Right click and select remove other columns, use the same process and select remove duplicate.



Step 3: Go to add column and select add conditional column. Give a name to the column (School Type Group) and then follow the GIF and the screenshot to create the column. Click OK




Step 4: Go to add column, select conditional column. Provide name to the column (School type Order) and Follow the GIF and Screenshot to create the column. Click OK




Step 5: Rename the table with School type then select close and apply








https://radacad.com/conditional-column-in-power-bi-using-power-query-you-can-do-anything

Conditional column in power bi  using power query